How to: Create custom number formats.
Solution:
Select 'Cells...' from the 'Format' menu, click the 'Number' tab, and create the desired format based on a predefined format.
1) Select the cells to format.
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Number' tab.
4) Select the desired type of number format from the 'Category' list box. (The built-in format of that type appears on the right.)
5) If more than one built-in format appears, select the format that most closely resembles the desired format.
Selecting a built-in format
6) Select 'Custom' from the 'Category' list box. (The code for the selected format appears in the Type box.)
7) Modify the format code to create the desired format in the 'Type' box.
Modifying the format code
NOTE: Modifying a built-in format does not remove or change the original format.
8) Click 'OK' to save the change and close the 'Format Cells' dialog box.
